package com.gg.common.mapper;

import com.gg.common.pojo.SPay;

import java.util.List;

public interface SPayMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(SPay record);

    int insertSelective(SPay record);

    SPay selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(SPay record);

    int updateByPrimaryKey(SPay record);

    /**
     * TODO 添加出库申请登记
     * @param sPay
     * @return SPay
     * @throws Exception
     */
    int saveWarehouseRegistration(SPay sPay) throws Exception;

    /**
     * TODO 查询出库申请登记审核
     * @return SPays
     * @throws Exception
     */
    List<SPay> queryWarehouseAuditing() throws Exception;

    /**
     * TODO 出库申请查询
     * @return SPays
     * @throws Exception
     */
    List<SPay> queryWarehouse() throws Exception;

    /**
     * TODO 查询审核已通过库存单
     * @return SPays
     * @throws Exception
     */
    List<SPay> queryWarehouseCheckTagApprove() throws Exception;

    /**
     * TODO 查询已调度出库单
     * @return SPays
     * @throws Exception
     */
    List<SPay> queryWarehouseScheduled() throws Exception;

    /**
     * TODO 查询已登记出库单
     * @return SPays
     * @throws Exception
     */
    List<SPay> queryWarehouseRegistrationCheck() throws Exception;

    /**
     *  TODO 查询出库单是否已经全部出库
     * @param id
     * @return
     * @throws Exception
     */
    SPay queryByIdOutWarehouse(int id) throws Exception;

    /**
     * TODO 出库查询
     * @return SPays
     * @throws Exception
     */
    List<SPay> queryOutWarehouse() throws Exception;
}